acc219c12bbd165de3bf9a1aae87cb6aa87a1dc2,src/main/java/db/DbManager.java,DbManager,getFieldValue,#String#String#String#String#,36
Before Change
String query = "SELECT " + field + " FROM " + table + " WHERE " + keyName + "=?";
try
{
PreparedStatement statement = connection.prepareStatement(query);
statement.setString(1, keyValue);
ResultSet resultSet = statement.executeQuery();
if (resultSet.next())
{
fieldValue = resultSet.getString(1);
}
resultSet.close();
statement.close();
}
catch (SQLException e)
After Change
ResultSet resultSet = null;
try
{
statement = connection.prepareStatement(query);
statement.setString(1, keyValue);
resultSet = statement.executeQuery();
if (resultSet.next())
{
fieldValue = resultSet.getString(1);